Diagram ECP

Defincja diagramu ECP

Name

ECP

Code

ECP

Comment

Ewidencja Czasu Pracy


Lista tabel diagramu

Name

Code

EcpCardReaderInstance

EcpCardReaderInstance

EcpDeviceAction

EcpDeviceAction

EcpDeviceActionDetail

EcpDeviceActionDetail

EcpDeviceActionType

EcpDeviceActionType

EcpDeviceActionTypeText

EcpDeviceActionTypeText

EcpDeviceResponseStatus

EcpDeviceResponseStatus

EcpDeviceResponseStatusText

EcpDeviceResponseStatusText

EcpUserDefinition

EcpUserDefinition

EcpUserEvent

EcpUserEvent

EcpUserEventResource

EcpUserEventResource

EcpUserEventStatus

EcpUserEventStatus

EcpUserEventStatusText

EcpUserEventStatusText

EcpUserEventType

EcpUserEventType

EcpUserEventTypeText

EcpUserEventTypeText

Person

Person


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2701

R_2701

EcpCardReaderInstance

EcpDeviceActionDetail

EcpCardReaderInstanceId

 

 

R_2702

R_2702

EcpCardReaderInstance

EcpUserEvent

EcpCardReaderInstanceId

 

 

R_2703

R_2703

EcpDeviceAction

EcpDeviceActionDetail

EcpDeviceActionId

 

 

R_2704

R_2704

EcpDeviceAction

EcpUserEvent

EcpDeviceActionId

 

 

R_2706

R_2706

EcpDeviceActionType

EcpDeviceAction

EcpDeviceActionTypeId

 

 

R_2707

R_2707

EcpDeviceActionType

EcpDeviceActionTypeText

EcpDeviceActionTypeId

 

 

R_2708

R_2708

EcpDeviceResponseStatus

EcpDeviceActionDetail

EcpDeviceResponseStatusId

 

 

R_2710

R_2710

EcpDeviceResponseStatus

EcpDeviceResponseStatusText

EcpDeviceResponseStatusId

 

 

R_2712

R_2712

EcpUserEventResource

EcpUserEvent

EcpUserEventResourceId

 

 

R_2713

R_2713

EcpUserEventStatus

EcpUserEvent

EcpUserEventStatusId

 

 

R_2714

R_2714

EcpUserEventStatus

EcpUserEventStatusText

EcpUserEventStatusId

 

 

R_2715

R_2715

EcpUserEventType

EcpUserEvent

EcpUserEventTypeId

 

 

R_2716

R_2716

EcpUserEventType

EcpUserEventTypeText

EcpUserEventTypeId

 

 

R_9720

R_9720

Person

EcpUserDefinition

PersonId

 

 

R_9721

R_9721

Person

EcpUserEvent

PersonId